<Query Kind="Expression">
  <Connection>
    <ID>cb5cbfdf-4288-45a0-97fb-92e01a87b1ee</ID>
    <Persist>true</Persist>
    <Server>.</Server>
    <Database>NORTHWND</Database>
    <ShowServer>true</ShowServer>
  </Connection>
</Query>

/*
from x in Products
	join c in Categories on
x.CategoryID equals c.CategoryID
	join s in Suppliers on
x.SupplierID equals s.SupplierID 
select new
{
	productName=x.ProductName,
	category=c.CategoryName,
	suplier = s.CompanyName
}
*/
/*
//join 2 tables
from t in Territories
	join r in Regions
		on t.RegionID equals r.RegionID
select new
{
	disctiption = t.TerritoryDescription,
	region = r.RegionDescription
}
*/
/*
//join 3 tables
from a in EmployeeTerritories
	join t in Territories 
		on a.TerritoryID equals t.TerritoryID
	join e in Employees
		on a.EmployeeID equals e.EmployeeID
select new
{
	Name = e.FirstName + " " + e.LastName,
	Teritory = t.TerritoryDescription
}
*/	
		
	
	
		

